#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql

# 查询所有字段
def list_col(localhost, username, password, database, tabls_name):
    db = pymysql.connect(localhost, username, password, database, charset="utf8")
    cursor = db.cursor()
    cursor.execute("select * from %s" % tabls_name)
    col_name_list = [tuple[0] for tuple in cursor.description]
    db.close()
    return col_name_list

# 列出所有的表
def list_table(localhost, username, password, database):
    db = pymysql.connect(localhost, username, password, database, charset="utf8")
    cursor = db.cursor()
    cursor.execute("show tables")
    table_list = [tuple[0] for tuple in cursor.fetchall()]
    db.close()
    return table_list

#
# username = "root" # 用户名
# password = "gaojingyu123" # 连接密码
# localhost = "127.0.0.1" # 连接地址
# database = "api_test" # 数据库名
# tables = list_table(localhost, username, password, database) # 获取所有表，返回的是一个可迭代对象
# # print(tables)
# # print(len(tables))
# # print(type
# #       (tables))
#
# for table in tables:
#     col_names = list_col(localhost, username, password, database, table)
#     # print(col_names) # 输出所有字段名
